SUPPORT / SAMPLES & SAS NOTES
Problem Note 54738: Performance in SAS® Promotion Optimization might be slow when loading promotions that include vendor deals
 |  |  |  |  |
In SAS Promotion Optimization, performance might be slow when loading promotions that include vendor deals. Slow performance might be observed in the Promotion List view and the Promotion Details view. The slow performance occurs because of a missing index for the RPP_VENDOR_DEAL table.
The workaround for this issue is to add the missing index by running the code below in a SAS session where the MI libraries are allocated:
%let m_sql_statement = %str( create index RPP_VENDOR_DEAL_IX5 on RPP_VENDOR_DEAL (abs(PLAN_SK)) );
%di_dm_trans_exe(pass_through_sql=%quote(&m_sql_statement),session_flg=1);
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 5.2 | 5.4 | 9.3 TS1M1 | 9.4 TS1M3 | ||